CREATE TABLE [dbo].[Doctor]
(
[DoctorCode] [nchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FirstName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiddleName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Speciality] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsExpat] [bit] NOT NULL CONSTRAINT [DF_Doctor_IsExpat] DEFAULT ((0)),
[IsDisabled] [bit] NOT NULL CONSTRAINT [DF_Doctor_IsDisabled] DEFAULT ((0)),
[Remark] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Doctor] ADD CONSTRAINT [PK_Doctor] PRIMARY KEY CLUSTERED  ([DoctorCode]) ON [PRIMARY]
GO
